#603 — June 12, 2025 |
|
Postgres Weekly |
|
|
Announcing Multigres: Vitess for Postgres — Vitess is a popular clustering system for scaling and sharding MySQL. Supabase has hired Sugu Sougoumarane, one of its creators, to build a Vitess for Postgres, using everything learnt building Vitess over the years. Citus and PgDog are other options in this space, but Sugu thinks there’s more that can be done. Paul Copplestone (Supabase) |
|
AWS Open Sources Amazon |
O’Reilly’s Definitive Guide to CockroachDB (2nd Edition) — Master building scalable, resilient apps with a distributed SQL database that speaks Postgres. Enjoy familiar tools and queries — plus built-in global scale, geo-data control, and low TCO — on-prem or in any cloud. Cockroach Labs sponsor |
|
IN BRIEF:
|
|
▶ Compiling Postgres to WebAssembly with PGlite — PGlite is a neat project that’s a complete WASM build of Postgres, enabling Postgres to run in some unusual contexts, such as right in the browser. This talk explains the project and some of the complexities involved in making it work. Sam Willis |
|
📄 Approximate the P99 of a Query with 📄 Using Regular Expressions and Arrays in Postgres – A reminder of the basics. Hans-Jürgen Schönig 📄 Don't Mock The Database: Data Fixtures are Parallel Safe and Fast Brandur Leach (Crunchy Data) 📄 Features I Wish MySQL Had But Postgres Already Has Tianzhou |
🛠 Code and Tools |
|
py-pglite: A PGlite Wrapper in Python for Testing — Install a Python package and get a PGlite-powered WebAssembly Postgres instance ready to roll with no Docker, setup, or config files needed. Wey Gu |
|
pgrwl: Stream Postgres WALs with Zero Data Loss — A write-ahead log (WAL) receiver written in Go. It’s a drop-in, container-friendly alternative to pg_receivewal, supporting streaming replication, encryption, compression, and remote storage (S3, SFTP). Alexey ZH |
|
Greenmask: Postgres Data Masking and Obfuscation Tool — A Go-powered utility for dumping a Postgres database and anonymizing the data in a deterministic way. GitHub repo. Greenmask |
|
Postgres CDC Connector for ClickPipes Now Generally Available
|
|
|